﻿INSERT INTO [SkyNetLibrary].[dbo].[Authors]
           ([Id]
           ,[FirstName]
           ,[LastName]
           ,[WebSite]
           ,[Photo]
           ,[RowId])
     VALUES
           ('7884BEC3-369F-441E-8AAF-69474400DC55'
           ,'George Shepherd'
           ,'George Shepherd'
           ,'http://oreilly.com/catalog/9780735627017/'
           ,'http://covers.oreilly.com/images/9780735627017/cat.gif'
           ,NEWID())

go

INSERT INTO [SkyNetLibrary].[dbo].[Authors]
           ([Id]
           ,[FirstName]
           ,[LastName]
           ,[WebSite]
           ,[Photo]
           ,[RowId])
     VALUES
           ('67616901-8B8C-4E88-834A-D0C317868D35'
           ,'Judith Bishop'
           ,'Judith Bishop'
           ,'http://www.oreillynet.com/pub/au/3005'
           ,'http://www.oreillynet.com/images/people/154/judith_bishop.jpg'
           ,NEWID())
GO
INSERT INTO [SkyNetLibrary].[dbo].[Publishers]
           ([Id]
           ,[Logo]
           ,[Name]
           ,[WebSite])
     VALUES
           ('546F306C-1276-4737-B9E5-EE345EB3AFC7'
           ,null
           ,'oreilly'
           ,'http://oreilly.com/')
GO

INSERT INTO [SkyNetLibrary].[dbo].[Subjects]
           ([Id]
           ,[Description]
           ,[Name])
     VALUES
           ('AD5517E0-516A-44F0-AF2B-199B3202B438'
           ,'TI'
           ,'Tech')
GO



INSERT INTO [SkyNetLibrary].[dbo].[Books]
           ([Id]
           ,[Isbn]
           ,[Notes]
           ,[PageCount]
           ,[Price]
           ,[PublicationDate]
           ,[Summary]
           ,[Title]
           ,[AuthorId]
           ,[PublisherId]
           ,[SubjectId])
     VALUES
           ('85B97B84-6A59-449C-B223-2D9A9C081221'
           ,'978-0-7356-4536-3'
           ,''
           ,640
           ,44.90
           ,'01-04-2010'
           ,'Microsoft® ASP.NET 4 Step by Step'
           ,'Microsoft® ASP.NET 4 Step by Step'
           ,'7884BEC3-369F-441E-8AAF-69474400DC55'
           ,'546F306C-1276-4737-B9E5-EE345EB3AFC7'
           ,'AD5517E0-516A-44F0-AF2B-199B3202B438')
GO
INSERT INTO [SkyNetLibrary].[dbo].[Books]
           ([Id]
           ,[Isbn]
           ,[Notes]
           ,[PageCount]
           ,[Price]
           ,[PublicationDate]
           ,[Summary]
           ,[Title]
           ,[AuthorId]
           ,[PublisherId]
           ,[SubjectId])
     VALUES
           ('C5B98B82-6A58-449C-B223-2D9A9C081A31'
           ,'978-0-7356-9103-2'
           ,''
           ,464
           ,39.90
           ,'01-11-2009'
           ,'Microsoft® ASP.NET 2.0 Step By Step'
           ,'Microsoft® ASP.NET 2.0 Step By Step'
           ,'7884BEC3-369F-441E-8AAF-69474400DC55'
           ,'546F306C-1276-4737-B9E5-EE345EB3AFC7'
           ,'AD5517E0-516A-44F0-AF2B-199B3202B438')
GO
INSERT INTO [SkyNetLibrary].[dbo].[Tipo]
           ([TipoId]
           ,[Titulo]
           ,[Descripcion])
     VALUES
           (NEWID()
           ,'Texto'
           ,'Texto')
GO